Overview
Brought to you by YData
Dataset statistics
| Number of variables | 40 |
|---|---|
| Number of observations | 19041 |
| Missing cells | 334368 |
| Missing cells (%) | 43.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 25.9 MiB |
| Average record size in memory | 1.4 KiB |
Variable types
| Text | 8 |
|---|---|
| Categorical | 8 |
| Numeric | 2 |
| Unsupported | 17 |
| DateTime | 5 |
Modalidad de atencion has constant value "Presencial" | Constant |
Carpeta is highly overall correlated with Fila and 2 other fields | High correlation |
Codigo de Oficina is highly overall correlated with Oficina | High correlation |
Fila is highly overall correlated with Carpeta and 2 other fields | High correlation |
Oficina is highly overall correlated with Codigo de Oficina | High correlation |
Perdido is highly overall correlated with Saltado | High correlation |
Prefijo Ticket is highly overall correlated with Carpeta and 2 other fields | High correlation |
Saltado is highly overall correlated with Perdido | High correlation |
Segmento is highly overall correlated with Carpeta and 2 other fields | High correlation |
Perdido is highly imbalanced (98.6%) | Imbalance |
Saltado is highly imbalanced (98.6%) | Imbalance |
DNI Ejecutivo DV has 19041 (100.0%) missing values | Missing |
DNI Cliente DV has 19041 (100.0%) missing values | Missing |
Email Cliente has 18793 (98.7%) missing values | Missing |
Rating has 19041 (100.0%) missing values | Missing |
Comentario has 19041 (100.0%) missing values | Missing |
Nombre Cliente has 4715 (24.8%) missing values | Missing |
Formulario has 19041 (100.0%) missing values | Missing |
Segmento has 4965 (26.1%) missing values | Missing |
ID de llamada anterior has 19041 (100.0%) missing values | Missing |
UTM has 19041 (100.0%) missing values | Missing |
ID Submotivos has 19041 (100.0%) missing values | Missing |
Submotivos de atencion has 19041 (100.0%) missing values | Missing |
Carpeta has 1233 (6.5%) missing values | Missing |
Categorizacion-Derivacion has 19041 (100.0%) missing values | Missing |
Tipo de cliente has 19041 (100.0%) missing values | Missing |
Pregunta Botonera has 19041 (100.0%) missing values | Missing |
Carpeta de motivos has 19041 (100.0%) missing values | Missing |
Preferencia Usuario has 19041 (100.0%) missing values | Missing |
Submotivos v2 has 19041 (100.0%) missing values | Missing |
Sucursal de origen has 19041 (100.0%) missing values | Missing |
ID Ticket has unique values | Unique |
ID Llamada has unique values | Unique |
Modulo is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DNI Ejecutivo DV is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DNI Cliente DV is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Rating is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Comentario is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Formulario is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ID de llamada anterior is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
UTM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ID Submotivos is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Submotivos de atencion is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Categorizacion-Derivacion is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Tipo de cliente is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Pregunta Botonera is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Carpeta de motivos is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Preferencia Usuario is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Submotivos v2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Sucursal de origen is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-11-29 18:08:39.022559 |
|---|---|
| Analysis finished | 2024-11-29 18:08:46.815802 |
| Duration | 7.79 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
ID Ticket
Text
Unique
| Distinct | 19041 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 14.160653 |
| Min length | 14 |
Unique
| Unique | 19041 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | T3270200138752 |
|---|---|
| 2nd row | T3270200274435 |
| 3rd row | T3270200199076 |
| 4th row | T3270200210373 |
| 5th row | T3270200318250 |
| Value | Count | Frequency (%) |
| t3270200138752 | 1 | < 0.1% |
| t3270200199076 | 1 | < 0.1% |
| t3270200318250 | 1 | < 0.1% |
| t3270200464273 | 1 | < 0.1% |
| t3270200587221 | 1 | < 0.1% |
| t3270200643964 | 1 | < 0.1% |
| t3270200784328 | 1 | < 0.1% |
| t3270200857982 | 1 | < 0.1% |
| t3270200124178 | 1 | < 0.1% |
| t3270200201637 | 1 | < 0.1% |
| Other values (19031) | 19031 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 47715 | |
| 3 | 43557 | |
| 1 | 30549 | |
| 0 | 29146 | |
| 8 | 20361 | |
| T | 19041 | 7.1% |
| 7 | 18042 | 6.7% |
| 9 | 17360 | 6.4% |
| 4 | 15676 | 5.8% |
| 5 | 14778 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 269633 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 47715 | |
| 3 | 43557 | |
| 1 | 30549 | |
| 0 | 29146 | |
| 8 | 20361 | |
| T | 19041 | 7.1% |
| 7 | 18042 | 6.7% |
| 9 | 17360 | 6.4% |
| 4 | 15676 | 5.8% |
| 5 | 14778 | 5.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 269633 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 47715 | |
| 3 | 43557 | |
| 1 | 30549 | |
| 0 | 29146 | |
| 8 | 20361 | |
| T | 19041 | 7.1% |
| 7 | 18042 | 6.7% |
| 9 | 17360 | 6.4% |
| 4 | 15676 | 5.8% |
| 5 | 14778 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 269633 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 47715 | |
| 3 | 43557 | |
| 1 | 30549 | |
| 0 | 29146 | |
| 8 | 20361 | |
| T | 19041 | 7.1% |
| 7 | 18042 | 6.7% |
| 9 | 17360 | 6.4% |
| 4 | 15676 | 5.8% |
| 5 | 14778 | 5.5% |
ID Llamada
Text
Unique
| Distinct | 19041 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 38 |
| Mean length | 38.160653 |
| Min length | 38 |
Unique
| Unique | 19041 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C2509732198327020013875217307240683370 |
|---|---|
| 2nd row | C2509732198327020027443517307334890300 |
| 3rd row | C2509732202327020019907617307247753890 |
| 4th row | C2509732202327020021037317307250432900 |
| 5th row | C2555532202327020031825017307254844290 |
| Value | Count | Frequency (%) |
| c2509732198327020013875217307240683370 | 1 | < 0.1% |
| c2509732202327020019907617307247753890 | 1 | < 0.1% |
| c2555532202327020031825017307254844290 | 1 | < 0.1% |
| c2555532202327020046427317307268761580 | 1 | < 0.1% |
| c2555532202327020058722117307292716520 | 1 | < 0.1% |
| c2555532202327020064396417307302644760 | 1 | < 0.1% |
| c2545732202327020078432817307368992670 | 1 | < 0.1% |
| c2555532202327020085798217307420757140 | 1 | < 0.1% |
| c2555532201327020012417817307352522110 | 1 | < 0.1% |
| c2555532201327020020163717307372192060 | 1 | < 0.1% |
| Other values (19031) | 19031 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 116971 | |
| 3 | 112403 | |
| 1 | 99310 | |
| 0 | 83299 | |
| 5 | 65130 | |
| 7 | 59986 | |
| 8 | 48719 | |
| 9 | 43529 | 6.0% |
| 4 | 43344 | 6.0% |
| 6 | 34885 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 726617 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 116971 | |
| 3 | 112403 | |
| 1 | 99310 | |
| 0 | 83299 | |
| 5 | 65130 | |
| 7 | 59986 | |
| 8 | 48719 | |
| 9 | 43529 | 6.0% |
| 4 | 43344 | 6.0% |
| 6 | 34885 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 726617 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 116971 | |
| 3 | 112403 | |
| 1 | 99310 | |
| 0 | 83299 | |
| 5 | 65130 | |
| 7 | 59986 | |
| 8 | 48719 | |
| 9 | 43529 | 6.0% |
| 4 | 43344 | 6.0% |
| 6 | 34885 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 726617 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 116971 | |
| 3 | 112403 | |
| 1 | 99310 | |
| 0 | 83299 | |
| 5 | 65130 | |
| 7 | 59986 | |
| 8 | 48719 | |
| 9 | 43529 | 6.0% |
| 4 | 43344 | 6.0% |
| 6 | 34885 | 4.8% |
Oficina
Categorical
High correlation
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| AFP PlanVital Tenderini | |
|---|---|
| AFP PlanVital Concepcion | 1021 |
| AFP PlanVital Temuco | 890 |
| AFP PlanVital Apoquindo | 821 |
| AFP PlanVital Talca | 768 |
| Other values (32) |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 22.484271 |
| Min length | 19 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AFP PlanVital Antofagasta |
|---|---|
| 2nd row | AFP PlanVital Antofagasta |
| 3rd row | AFP PlanVital Antofagasta |
| 4th row | AFP PlanVital Antofagasta |
| 5th row | AFP PlanVital Antofagasta |
Common Values
| Value | Count | Frequency (%) |
| AFP PlanVital Tenderini | 3284 | 17.2% |
| AFP PlanVital Concepcion | 1021 | 5.4% |
| AFP PlanVital Temuco | 890 | 4.7% |
| AFP PlanVital Apoquindo | 821 | 4.3% |
| AFP PlanVital Talca | 768 | 4.0% |
| AFP PlanVital La Serena | 690 | 3.6% |
| AFP PlanVital Rancagua | 678 | 3.6% |
| AFP PlanVital Maipu | 626 | 3.3% |
| AFP PlanVital San Fernando | 609 | 3.2% |
| AFP PlanVital Vina del Mar | 600 | 3.2% |
| Other values (27) | 9054 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| afp | 19041 | |
| planvital | 19041 | |
| tenderini | 3284 | 5.3% |
| san | 1663 | 2.7% |
| concepcion | 1021 | 1.6% |
| temuco | 890 | 1.4% |
| apoquindo | 821 | 1.3% |
| talca | 768 | 1.2% |
| la | 690 | 1.1% |
| serena | 690 | 1.1% |
| Other values (37) | 14502 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 55345 | |
| l | 43528 | |
| 43370 | ||
| n | 39065 | |
| P | 38987 | |
| i | 34209 | 8.0% |
| t | 23535 | 5.5% |
| A | 21863 | 5.1% |
| V | 20803 | 4.9% |
| F | 19867 | 4.6% |
| Other values (25) | 87551 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 428123 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 55345 | |
| l | 43528 | |
| 43370 | ||
| n | 39065 | |
| P | 38987 | |
| i | 34209 | 8.0% |
| t | 23535 | 5.5% |
| A | 21863 | 5.1% |
| V | 20803 | 4.9% |
| F | 19867 | 4.6% |
| Other values (25) | 87551 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 428123 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 55345 | |
| l | 43528 | |
| 43370 | ||
| n | 39065 | |
| P | 38987 | |
| i | 34209 | 8.0% |
| t | 23535 | 5.5% |
| A | 21863 | 5.1% |
| V | 20803 | 4.9% |
| F | 19867 | 4.6% |
| Other values (25) | 87551 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 428123 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 55345 | |
| l | 43528 | |
| 43370 | ||
| n | 39065 | |
| P | 38987 | |
| i | 34209 | 8.0% |
| t | 23535 | 5.5% |
| A | 21863 | 5.1% |
| V | 20803 | 4.9% |
| F | 19867 | 4.6% |
| Other values (25) | 87551 |
Codigo de Oficina
Real number (ℝ)
High correlation
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 65.771388 |
| Minimum | 20 |
|---|---|
| Maximum | 186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 148.9 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 47 |
| median | 61 |
| Q3 | 84 |
| 95-th percentile | 124 |
| Maximum | 186 |
| Range | 166 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 30.254602 |
|---|---|
| Coefficient of variation (CV) | 0.45999641 |
| Kurtosis | 3.2490523 |
| Mean | 65.771388 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 1.2988819 |
| Sum | 1252353 |
| Variance | 915.34096 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=37)
| Value | Count | Frequency (%) |
| 50 | 3284 | 17.2% |
| 80 | 1021 | 5.4% |
| 91 | 890 | 4.7% |
| 124 | 821 | 4.3% |
| 72 | 768 | 4.0% |
| 41 | 690 | 3.6% |
| 61 | 678 | 3.6% |
| 56 | 626 | 3.3% |
| 62 | 609 | 3.2% |
| 47 | 600 | 3.2% |
| Other values (27) | 9054 |
| Value | Count | Frequency (%) |
| 20 | 405 | |
| 21 | 295 | |
| 22 | 465 | |
| 23 | 403 | |
| 24 | 323 | |
| 31 | 217 | 1.1% |
| 40 | 367 | |
| 41 | 690 | |
| 43 | 366 | |
| 44 | 164 | 0.9% |
| Value | Count | Frequency (%) |
| 186 | 383 | |
| 124 | 821 | |
| 98 | 119 | 0.6% |
| 97 | 177 | 0.9% |
| 96 | 200 | 1.1% |
| 95 | 233 | 1.2% |
| 94 | 420 | |
| 93 | 587 | |
| 92 | 371 | |
| 91 | 890 |
Fila
Categorical
High correlation
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Certificados | |
|---|---|
| Otros Pensionado | |
| Otros | |
| Solicitud tramite de pension | |
| Liquidacion de pension | |
| Other values (8) |
Length
| Max length | 28 |
|---|---|
| Median length | 19 |
| Mean length | 14.761777 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Actualizacion de datos |
|---|---|
| 2nd row | Actualizacion de datos |
| 3rd row | Certificados |
| 4th row | Certificados |
| 5th row | Certificados |
Common Values
| Value | Count | Frequency (%) |
| Certificados | 5521 | |
| Otros Pensionado | 3453 | |
| Otros | 3352 | |
| Solicitud tramite de pension | 2396 | |
| Liquidacion de pension | 1299 | 6.8% |
| Actualizacion de datos | 896 | 4.7% |
| Empleador | 787 | 4.1% |
| Giro APV o Cuenta 2 | 692 | 3.6% |
| Traspaso | 241 | 1.3% |
| Pago en exceso | 154 | 0.8% |
| Other values (3) | 250 | 1.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| otros | 6805 | |
| certificados | 5521 | |
| de | 4633 | |
| pension | 3838 | |
| pensionado | 3453 | |
| solicitud | 2396 | 6.4% |
| tramite | 2396 | 6.4% |
| liquidacion | 1299 | 3.5% |
| actualizacion | 896 | 2.4% |
| datos | 896 | 2.4% |
| Other values (14) | 5242 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 32074 | |
| o | 31403 | |
| t | 22063 | 7.8% |
| e | 21847 | 7.8% |
| s | 21214 | 7.5% |
| d | 19027 | 6.8% |
| 18334 | 6.5% | |
| n | 17730 | 6.3% |
| a | 17644 | 6.3% |
| r | 16507 | 5.9% |
| Other values (23) | 63236 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 281079 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 32074 | |
| o | 31403 | |
| t | 22063 | 7.8% |
| e | 21847 | 7.8% |
| s | 21214 | 7.5% |
| d | 19027 | 6.8% |
| 18334 | 6.5% | |
| n | 17730 | 6.3% |
| a | 17644 | 6.3% |
| r | 16507 | 5.9% |
| Other values (23) | 63236 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 281079 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 32074 | |
| o | 31403 | |
| t | 22063 | 7.8% |
| e | 21847 | 7.8% |
| s | 21214 | 7.5% |
| d | 19027 | 6.8% |
| 18334 | 6.5% | |
| n | 17730 | 6.3% |
| a | 17644 | 6.3% |
| r | 16507 | 5.9% |
| Other values (23) | 63236 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 281079 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 32074 | |
| o | 31403 | |
| t | 22063 | 7.8% |
| e | 21847 | 7.8% |
| s | 21214 | 7.5% |
| d | 19027 | 6.8% |
| 18334 | 6.5% | |
| n | 17730 | 6.3% |
| a | 17644 | 6.3% |
| r | 16507 | 5.9% |
| Other values (23) | 63236 |
Modulo
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 706.3 KiB |
Fecha
Date
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.9 KiB |
| Minimum | 2024-11-04 00:00:00 |
|---|---|
| Maximum | 2024-11-28 00:00:00 |
Histogram with fixed size bins (bins=19)
Prefijo Ticket
Categorical
High correlation
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 940.6 KiB |
| AC | |
|---|---|
| P | |
| O | |
| PT | |
| PL | |
| Other values (9) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.5777008 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AD |
|---|---|
| 2nd row | AD |
| 3rd row | AC |
| 4th row | AC |
| 5th row | AC |
Common Values
| Value | Count | Frequency (%) |
| AC | 4458 | |
| P | 3453 | |
| O | 3352 | |
| PT | 2396 | |
| PL | 1299 | 6.8% |
| PS | 1063 | 5.6% |
| AD | 896 | 4.7% |
| E | 787 | 4.1% |
| AG | 692 | 3.6% |
| T | 241 | 1.3% |
| Other values (4) | 404 | 2.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ac | 4458 | |
| p | 3453 | |
| o | 3352 | |
| pt | 2396 | |
| pl | 1299 | 6.8% |
| ps | 1063 | 5.6% |
| ad | 896 | 4.7% |
| e | 787 | 4.1% |
| ag | 692 | 3.6% |
| t | 241 | 1.3% |
| Other values (4) | 404 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 8365 | |
| A | 6307 | |
| C | 4458 | |
| O | 3352 | |
| T | 2637 | 8.8% |
| L | 1299 | 4.3% |
| S | 1063 | 3.5% |
| D | 896 | 3.0% |
| E | 787 | 2.6% |
| G | 692 | 2.3% |
| Other values (2) | 185 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30041 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 8365 | |
| A | 6307 | |
| C | 4458 | |
| O | 3352 | |
| T | 2637 | 8.8% |
| L | 1299 | 4.3% |
| S | 1063 | 3.5% |
| D | 896 | 3.0% |
| E | 787 | 2.6% |
| G | 692 | 2.3% |
| Other values (2) | 185 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30041 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 8365 | |
| A | 6307 | |
| C | 4458 | |
| O | 3352 | |
| T | 2637 | 8.8% |
| L | 1299 | 4.3% |
| S | 1063 | 3.5% |
| D | 896 | 3.0% |
| E | 787 | 2.6% |
| G | 692 | 2.3% |
| Other values (2) | 185 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30041 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 8365 | |
| A | 6307 | |
| C | 4458 | |
| O | 3352 | |
| T | 2637 | 8.8% |
| L | 1299 | 4.3% |
| S | 1063 | 3.5% |
| D | 896 | 3.0% |
| E | 787 | 2.6% |
| G | 692 | 2.3% |
| Other values (2) | 185 | 0.6% |
Nro. Ticket
Real number (ℝ)
| Distinct | 104 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3493514 |
| Minimum | 1 |
|---|---|
| Maximum | 104 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 148.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 7 |
| 95-th percentile | 26 |
| Maximum | 104 |
| Range | 103 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 9.5446983 |
|---|---|
| Coefficient of variation (CV) | 1.5032556 |
| Kurtosis | 19.180973 |
| Mean | 6.3493514 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.8178316 |
| Sum | 120898 |
| Variance | 91.101267 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 4793 | |
| 2 | 3191 | |
| 3 | 2239 | |
| 4 | 1643 | 8.6% |
| 5 | 1259 | 6.6% |
| 6 | 984 | 5.2% |
| 7 | 779 | 4.1% |
| 8 | 621 | 3.3% |
| 9 | 478 | 2.5% |
| 10 | 390 | 2.0% |
| Other values (94) | 2664 |
| Value | Count | Frequency (%) |
| 1 | 4793 | |
| 2 | 3191 | |
| 3 | 2239 | |
| 4 | 1643 | 8.6% |
| 5 | 1259 | 6.6% |
| 6 | 984 | 5.2% |
| 7 | 779 | 4.1% |
| 8 | 621 | 3.3% |
| 9 | 478 | 2.5% |
| 10 | 390 | 2.0% |
| Value | Count | Frequency (%) |
| 104 | 1 | |
| 103 | 1 | |
| 102 | 1 | |
| 101 | 1 | |
| 100 | 1 | |
| 99 | 1 | |
| 98 | 1 | |
| 97 | 1 | |
| 96 | 1 | |
| 95 | 1 |
DNI Ejecutivo
Text
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.9312011 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 12612953-K |
|---|---|
| 2nd row | 12612953-K |
| 3rd row | 12612953-K |
| 4th row | 12612953-K |
| 5th row | 19445974-2 |
| Value | Count | Frequency (%) |
| 15253118-4 | 532 | 2.8% |
| 13773752-3 | 480 | 2.5% |
| 17051427-0 | 422 | 2.2% |
| 16386186-0 | 384 | 2.0% |
| 13896868-5 | 383 | 2.0% |
| 15603817-2 | 367 | 1.9% |
| 16542180-9 | 347 | 1.8% |
| 15989433-9 | 345 | 1.8% |
| 17769282-4 | 339 | 1.8% |
| 12296514-7 | 331 | 1.7% |
| Other values (108) | 15111 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 31955 | |
| - | 19041 | |
| 7 | 18183 | |
| 5 | 17873 | |
| 3 | 17035 | |
| 2 | 16937 | |
| 6 | 14096 | |
| 8 | 13647 | |
| 9 | 13540 | |
| 4 | 13240 | |
| Other values (2) | 13553 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 189100 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 31955 | |
| - | 19041 | |
| 7 | 18183 | |
| 5 | 17873 | |
| 3 | 17035 | |
| 2 | 16937 | |
| 6 | 14096 | |
| 8 | 13647 | |
| 9 | 13540 | |
| 4 | 13240 | |
| Other values (2) | 13553 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 189100 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 31955 | |
| - | 19041 | |
| 7 | 18183 | |
| 5 | 17873 | |
| 3 | 17035 | |
| 2 | 16937 | |
| 6 | 14096 | |
| 8 | 13647 | |
| 9 | 13540 | |
| 4 | 13240 | |
| Other values (2) | 13553 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 189100 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 31955 | |
| - | 19041 | |
| 7 | 18183 | |
| 5 | 17873 | |
| 3 | 17035 | |
| 2 | 16937 | |
| 6 | 14096 | |
| 8 | 13647 | |
| 9 | 13540 | |
| 4 | 13240 | |
| Other values (2) | 13553 |
DNI Ejecutivo DV
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Nombre Ejecutivo
Text
| Distinct | 119 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 31 |
| Mean length | 25.133659 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HENRIQUEZ HUERTA, VANESSA |
|---|---|
| 2nd row | HENRIQUEZ HUERTA, VANESSA |
| 3rd row | HENRIQUEZ HUERTA, VANESSA |
| 4th row | HENRIQUEZ HUERTA, VANESSA |
| 5th row | MARJORIE NEVENKA PIZARRO OCARANZA |
| Value | Count | Frequency (%) |
| munoz | 1287 | 2.1% |
| gonzalez | 1240 | 2.0% |
| soto | 1210 | 1.9% |
| del | 897 | 1.4% |
| andrea | 776 | 1.2% |
| torres | 725 | 1.2% |
| fuentes | 715 | 1.1% |
| pino | 697 | 1.1% |
| claudia | 648 | 1.0% |
| diaz | 644 | 1.0% |
| Other values (279) | 53679 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 71774 | |
| E | 46571 | 9.7% |
| 43477 | 9.1% | |
| R | 38846 | 8.1% |
| N | 32610 | 6.8% |
| O | 30819 | 6.4% |
| I | 26965 | 5.6% |
| L | 26277 | 5.5% |
| S | 19794 | 4.1% |
| , | 16523 | 3.5% |
| Other values (22) | 124914 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 478570 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 71774 | |
| E | 46571 | 9.7% |
| 43477 | 9.1% | |
| R | 38846 | 8.1% |
| N | 32610 | 6.8% |
| O | 30819 | 6.4% |
| I | 26965 | 5.6% |
| L | 26277 | 5.5% |
| S | 19794 | 4.1% |
| , | 16523 | 3.5% |
| Other values (22) | 124914 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 478570 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 71774 | |
| E | 46571 | 9.7% |
| 43477 | 9.1% | |
| R | 38846 | 8.1% |
| N | 32610 | 6.8% |
| O | 30819 | 6.4% |
| I | 26965 | 5.6% |
| L | 26277 | 5.5% |
| S | 19794 | 4.1% |
| , | 16523 | 3.5% |
| Other values (22) | 124914 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 478570 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 71774 | |
| E | 46571 | 9.7% |
| 43477 | 9.1% | |
| R | 38846 | 8.1% |
| N | 32610 | 6.8% |
| O | 30819 | 6.4% |
| I | 26965 | 5.6% |
| L | 26277 | 5.5% |
| S | 19794 | 4.1% |
| , | 16523 | 3.5% |
| Other values (22) | 124914 |
DNI Cliente
Text
| Distinct | 16072 |
|---|---|
| Distinct (%) | 84.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.5871015 |
| Min length | 1 |
Unique
| Unique | 13809 ? |
|---|---|
| Unique (%) | 72.5% |
Sample
| 1st row | 25310066-4 |
|---|---|
| 2nd row | 25328334-3 |
| 3rd row | 26268695-7 |
| 4th row | 19102988-7 |
| 5th row | 20246505-6 |
| Value | Count | Frequency (%) |
| 9725117-7 | 16 | 0.1% |
| 13257188-0 | 15 | 0.1% |
| 12872238-6 | 9 | < 0.1% |
| 27108951-1 | 9 | < 0.1% |
| 10117437-9 | 8 | < 0.1% |
| 15185929-1 | 7 | < 0.1% |
| 8311919-5 | 7 | < 0.1% |
| 9232879-1 | 7 | < 0.1% |
| 19112375-1 | 7 | < 0.1% |
| 6609835-4 | 6 | < 0.1% |
| Other values (16061) | 18947 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 21692 | |
| - | 19038 | |
| 2 | 17769 | |
| 8 | 16310 | |
| 9 | 15977 | |
| 7 | 15672 | |
| 5 | 15623 | |
| 6 | 15419 | |
| 0 | 15005 | |
| 4 | 14417 | |
| Other values (3) | 15626 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 182548 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 21692 | |
| - | 19038 | |
| 2 | 17769 | |
| 8 | 16310 | |
| 9 | 15977 | |
| 7 | 15672 | |
| 5 | 15623 | |
| 6 | 15419 | |
| 0 | 15005 | |
| 4 | 14417 | |
| Other values (3) | 15626 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 182548 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 21692 | |
| - | 19038 | |
| 2 | 17769 | |
| 8 | 16310 | |
| 9 | 15977 | |
| 7 | 15672 | |
| 5 | 15623 | |
| 6 | 15419 | |
| 0 | 15005 | |
| 4 | 14417 | |
| Other values (3) | 15626 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 182548 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 21692 | |
| - | 19038 | |
| 2 | 17769 | |
| 8 | 16310 | |
| 9 | 15977 | |
| 7 | 15672 | |
| 5 | 15623 | |
| 6 | 15419 | |
| 0 | 15005 | |
| 4 | 14417 | |
| Other values (3) | 15626 |
DNI Cliente DV
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
| Distinct | 13206 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.9 KiB |
| Minimum | 2024-11-29 08:40:45 |
|---|---|
| Maximum | 2024-11-29 17:34:45 |
Histogram with fixed size bins (bins=50)
Hora Llamada
Date
| Distinct | 13222 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.9 KiB |
| Minimum | 2024-11-29 08:41:00 |
|---|---|
| Maximum | 2024-11-29 17:39:34 |
Histogram with fixed size bins (bins=50)
Tiempo Espera
Date
| Distinct | 1351 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.9 KiB |
| Minimum | 2024-11-29 00:00:01 |
|---|---|
| Maximum | 2024-11-29 01:21:07 |
Histogram with fixed size bins (bins=50)
Tiempo Atencion
Date
| Distinct | 2702 |
|---|---|
| Distinct (%) | 14.2% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 148.9 KiB |
| Minimum | 2024-11-29 00:00:03 |
|---|---|
| Maximum | 2024-11-29 04:38:09 |
Histogram with fixed size bins (bins=50)
Motivo Atencion
Text
| Distinct | 148 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 1.2 MiB |
Length
| Max length | 96 |
|---|---|
| Median length | 92 |
| Mean length | 17.019908 |
| Min length | 5 |
Unique
| Unique | 54 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Otros |
|---|---|
| 2nd row | Actualizacion de Datos |
| 3rd row | Actualizacion de Datos |
| 4th row | Certificados |
| 5th row | Certificados |
| Value | Count | Frequency (%) |
| de | 6687 | |
| certificados | 5082 | |
| pension | 4369 | |
| otros | 3824 | |
| tramite | 2800 | 7.4% |
| actualizacion | 1643 | 4.3% |
| certificados,otros | 1643 | 4.3% |
| cai | 922 | 2.4% |
| cav | 922 | 2.4% |
| ccv | 907 | 2.4% |
| Other values (138) | 9204 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 33373 | 10.3% |
| e | 29740 | 9.2% |
| o | 27839 | 8.6% |
| t | 25810 | 8.0% |
| s | 24486 | 7.6% |
| r | 23392 | 7.2% |
| a | 21909 | 6.8% |
| 18965 | 5.9% | |
| d | 17027 | 5.3% |
| c | 15052 | 4.6% |
| Other values (31) | 86432 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 324025 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 33373 | 10.3% |
| e | 29740 | 9.2% |
| o | 27839 | 8.6% |
| t | 25810 | 8.0% |
| s | 24486 | 7.6% |
| r | 23392 | 7.2% |
| a | 21909 | 6.8% |
| 18965 | 5.9% | |
| d | 17027 | 5.3% |
| c | 15052 | 4.6% |
| Other values (31) | 86432 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 324025 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 33373 | 10.3% |
| e | 29740 | 9.2% |
| o | 27839 | 8.6% |
| t | 25810 | 8.0% |
| s | 24486 | 7.6% |
| r | 23392 | 7.2% |
| a | 21909 | 6.8% |
| 18965 | 5.9% | |
| d | 17027 | 5.3% |
| c | 15052 | 4.6% |
| Other values (31) | 86432 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 324025 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 33373 | 10.3% |
| e | 29740 | 9.2% |
| o | 27839 | 8.6% |
| t | 25810 | 8.0% |
| s | 24486 | 7.6% |
| r | 23392 | 7.2% |
| a | 21909 | 6.8% |
| 18965 | 5.9% | |
| d | 17027 | 5.3% |
| c | 15052 | 4.6% |
| Other values (31) | 86432 |
Perdido
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 948.5 KiB |
| no | |
|---|---|
| si | 24 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | no |
|---|---|
| 2nd row | no |
| 3rd row | no |
| 4th row | no |
| 5th row | no |
Common Values
| Value | Count | Frequency (%) |
| no | 19017 | |
| si | 24 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 19017 | |
| si | 24 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Saltado
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 948.5 KiB |
| no | |
|---|---|
| si | 24 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | no |
|---|---|
| 2nd row | no |
| 3rd row | no |
| 4th row | no |
| 5th row | no |
Common Values
| Value | Count | Frequency (%) |
| no | 19017 | |
| si | 24 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 19017 | |
| si | 24 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 38082 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 19017 | |
| o | 19017 | |
| s | 24 | 0.1% |
| i | 24 | 0.1% |
Email Cliente
Text
Missing
| Distinct | 199 |
|---|---|
| Distinct (%) | 80.2% |
| Missing | 18793 |
| Missing (%) | 98.7% |
| Memory size | 604.9 KiB |
Length
| Max length | 39 |
|---|---|
| Median length | 33 |
| Mean length | 22.83871 |
| Min length | 8 |
Unique
| Unique | 183 ? |
|---|---|
| Unique (%) | 73.8% |
Sample
| 1st row | SINCORREO@MNN.CL |
|---|---|
| 2nd row | SINCORREO@HOTMAIL.CL |
| 3rd row | MARITE.ARAYAC72@GMAIL.COM |
| 4th row | DURANZAPATA.KAMILA@GMAIL.COM |
| 5th row | JUDY@LIVE.CL |
| Value | Count | Frequency (%) |
| notiene@gmail.com | 9 | 3.6% |
| sincorreo@gmail.com | 9 | 3.6% |
| bernarda.moya@planvital.cl | 8 | 3.2% |
| notienecorreo@gmail.com | 7 | 2.8% |
| yohana.hernandez@lastorres.com | 5 | 2.0% |
| notiene@notiene.cl | 4 | 1.6% |
| no@gmail.com | 3 | 1.2% |
| catalinaanaismolinamolina@gmail.com | 3 | 1.2% |
| jairo.jara@planvital.cl | 3 | 1.2% |
| rivemepa@gmail.com | 2 | 0.8% |
| Other values (191) | 197 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 679 | |
| O | 497 | 8.8% |
| M | 463 | 8.2% |
| I | 449 | 7.9% |
| L | 425 | 7.5% |
| C | 377 | 6.7% |
| . | 326 | 5.8% |
| E | 325 | 5.7% |
| N | 312 | 5.5% |
| R | 286 | 5.0% |
| Other values (31) | 1525 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5664 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 679 | |
| O | 497 | 8.8% |
| M | 463 | 8.2% |
| I | 449 | 7.9% |
| L | 425 | 7.5% |
| C | 377 | 6.7% |
| . | 326 | 5.8% |
| E | 325 | 5.7% |
| N | 312 | 5.5% |
| R | 286 | 5.0% |
| Other values (31) | 1525 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5664 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 679 | |
| O | 497 | 8.8% |
| M | 463 | 8.2% |
| I | 449 | 7.9% |
| L | 425 | 7.5% |
| C | 377 | 6.7% |
| . | 326 | 5.8% |
| E | 325 | 5.7% |
| N | 312 | 5.5% |
| R | 286 | 5.0% |
| Other values (31) | 1525 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5664 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 679 | |
| O | 497 | 8.8% |
| M | 463 | 8.2% |
| I | 449 | 7.9% |
| L | 425 | 7.5% |
| C | 377 | 6.7% |
| . | 326 | 5.8% |
| E | 325 | 5.7% |
| N | 312 | 5.5% |
| R | 286 | 5.0% |
| Other values (31) | 1525 |
Rating
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Comentario
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Nombre Cliente
Text
Missing
| Distinct | 12287 |
|---|---|
| Distinct (%) | 85.8% |
| Missing | 4715 |
| Missing (%) | 24.8% |
| Memory size | 1.2 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 44 |
| Mean length | 28.550049 |
| Min length | 4 |
Unique
| Unique | 10671 ? |
|---|---|
| Unique (%) | 74.5% |
Sample
| 1st row | CARLOS ALBERTO RIASCOS ALOMIA |
|---|---|
| 2nd row | ELVIS JHONATHAN PAREDES SIESQUEN |
| 3rd row | JULIO CESAR CASTILLO RODRIGUEZ |
| 4th row | PEDRO ANTONIO ANGEL BUGUENO |
| 5th row | CAMILO ALFREDO MOLINA CARVAJAL |
| Value | Count | Frequency (%) |
| del | 1302 | 2.2% |
| carmen | 1090 | 1.9% |
| maria | 843 | 1.5% |
| luis | 635 | 1.1% |
| jose | 575 | 1.0% |
| gonzalez | 566 | 1.0% |
| juan | 542 | 0.9% |
| antonio | 541 | 0.9% |
| munoz | 478 | 0.8% |
| de | 437 | 0.8% |
| Other values (6526) | 51005 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 58161 | |
| 44214 | ||
| E | 38424 | |
| R | 34952 | 8.5% |
| O | 29450 | 7.2% |
| I | 26346 | 6.4% |
| N | 25966 | 6.3% |
| L | 24323 | 5.9% |
| S | 17841 | 4.4% |
| D | 13284 | 3.2% |
| Other values (40) | 96047 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 409008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 58161 | |
| 44214 | ||
| E | 38424 | |
| R | 34952 | 8.5% |
| O | 29450 | 7.2% |
| I | 26346 | 6.4% |
| N | 25966 | 6.3% |
| L | 24323 | 5.9% |
| S | 17841 | 4.4% |
| D | 13284 | 3.2% |
| Other values (40) | 96047 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 409008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 58161 | |
| 44214 | ||
| E | 38424 | |
| R | 34952 | 8.5% |
| O | 29450 | 7.2% |
| I | 26346 | 6.4% |
| N | 25966 | 6.3% |
| L | 24323 | 5.9% |
| S | 17841 | 4.4% |
| D | 13284 | 3.2% |
| Other values (40) | 96047 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 409008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 58161 | |
| 44214 | ||
| E | 38424 | |
| R | 34952 | 8.5% |
| O | 29450 | 7.2% |
| I | 26346 | 6.4% |
| N | 25966 | 6.3% |
| L | 24323 | 5.9% |
| S | 17841 | 4.4% |
| D | 13284 | 3.2% |
| Other values (40) | 96047 |
Formulario
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Segmento
Categorical
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4965 |
| Missing (%) | 26.1% |
| Memory size | 959.0 KiB |
| A | |
|---|---|
| P |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 9127 | |
| P | 4949 | |
| (Missing) | 4965 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 9127 | |
| p | 4949 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 9127 | |
| P | 4949 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 9127 | |
| P | 4949 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 9127 | |
| P | 4949 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 9127 | |
| P | 4949 |
ID de llamada anterior
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
UTM
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
ID Submotivos
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Submotivos de atencion
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Carpeta
Categorical
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1233 |
| Missing (%) | 6.5% |
| Memory size | 1.0 MiB |
| Afiliado | |
|---|---|
| Pensionado |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 8.9221698 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Afiliado |
|---|---|
| 2nd row | Afiliado |
| 3rd row | Afiliado |
| 4th row | Afiliado |
| 5th row | Afiliado |
Common Values
| Value | Count | Frequency (%) |
| Afiliado | 9597 | |
| Pensionado | 8211 | |
| (Missing) | 1233 | 6.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| afiliado | 9597 | |
| pensionado | 8211 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 27405 | |
| o | 26019 | |
| a | 17808 | |
| d | 17808 | |
| n | 16422 | |
| A | 9597 | 6.0% |
| f | 9597 | 6.0% |
| l | 9597 | 6.0% |
| P | 8211 | 5.2% |
| e | 8211 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 158886 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 27405 | |
| o | 26019 | |
| a | 17808 | |
| d | 17808 | |
| n | 16422 | |
| A | 9597 | 6.0% |
| f | 9597 | 6.0% |
| l | 9597 | 6.0% |
| P | 8211 | 5.2% |
| e | 8211 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 158886 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 27405 | |
| o | 26019 | |
| a | 17808 | |
| d | 17808 | |
| n | 16422 | |
| A | 9597 | 6.0% |
| f | 9597 | 6.0% |
| l | 9597 | 6.0% |
| P | 8211 | 5.2% |
| e | 8211 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 158886 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 27405 | |
| o | 26019 | |
| a | 17808 | |
| d | 17808 | |
| n | 16422 | |
| A | 9597 | 6.0% |
| f | 9597 | 6.0% |
| l | 9597 | 6.0% |
| P | 8211 | 5.2% |
| e | 8211 | 5.2% |
Categorizacion-Derivacion
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Modalidad de atencion
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Presencial |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Presencial |
|---|---|
| 2nd row | Presencial |
| 3rd row | Presencial |
| 4th row | Presencial |
| 5th row | Presencial |
Common Values
| Value | Count | Frequency (%) |
| Presencial | 19041 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| presencial | 19041 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 38082 | |
| P | 19041 | |
| r | 19041 | |
| s | 19041 | |
| n | 19041 | |
| c | 19041 | |
| i | 19041 | |
| a | 19041 | |
| l | 19041 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 190410 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 38082 | |
| P | 19041 | |
| r | 19041 | |
| s | 19041 | |
| n | 19041 | |
| c | 19041 | |
| i | 19041 | |
| a | 19041 | |
| l | 19041 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 190410 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 38082 | |
| P | 19041 | |
| r | 19041 | |
| s | 19041 | |
| n | 19041 | |
| c | 19041 | |
| i | 19041 | |
| a | 19041 | |
| l | 19041 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 190410 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 38082 | |
| P | 19041 | |
| r | 19041 | |
| s | 19041 | |
| n | 19041 | |
| c | 19041 | |
| i | 19041 | |
| a | 19041 | |
| l | 19041 |
Tipo de cliente
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Pregunta Botonera
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Carpeta de motivos
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Preferencia Usuario
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Submotivos v2
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Sucursal de origen
Unsupported
Missing Rejected Unsupported
| Missing | 19041 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 148.9 KiB |
Interactions
Correlations
| Carpeta | Codigo de Oficina | Fila | Nro. Ticket | Oficina | Perdido | Prefijo Ticket | Saltado | Segmento | |
|---|---|---|---|---|---|---|---|---|---|
| Carpeta | 1.000 | 0.115 | 0.898 | 0.066 | 0.190 | 0.000 | 1.000 | 0.000 | 0.656 |
| Codigo de Oficina | 0.115 | 1.000 | 0.133 | -0.065 | 0.999 | 0.015 | 0.137 | 0.015 | 0.110 |
| Fila | 0.898 | 0.133 | 1.000 | 0.094 | 0.157 | 0.023 | 1.000 | 0.023 | 0.613 |
| Nro. Ticket | 0.066 | -0.065 | 0.094 | 1.000 | 0.217 | 0.000 | 0.104 | 0.000 | 0.004 |
| Oficina | 0.190 | 0.999 | 0.157 | 0.217 | 1.000 | 0.035 | 0.156 | 0.035 | 0.166 |
| Perdido | 0.000 | 0.015 | 0.023 | 0.000 | 0.035 | 1.000 | 0.021 | 0.979 | 0.000 |
| Prefijo Ticket | 1.000 | 0.137 | 1.000 | 0.104 | 0.156 | 0.021 | 1.000 | 0.021 | 0.727 |
| Saltado | 0.000 | 0.015 | 0.023 | 0.000 | 0.035 | 0.979 | 0.021 | 1.000 | 0.000 |
| Segmento | 0.656 | 0.110 | 0.613 | 0.004 | 0.166 | 0.000 | 0.727 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| ID Ticket | ID Llamada | Oficina | Codigo de Oficina | Fila | Modulo | Fecha | Prefijo Ticket | Nro. Ticket | DNI Ejecutivo | DNI Ejecutivo DV | Nombre Ejecutivo | DNI Cliente | DNI Cliente DV | Hora Emision Ticket | Hora Llamada | Tiempo Espera | Tiempo Atencion | Motivo Atencion | Perdido | Saltado | Email Cliente | Rating | Comentario | Nombre Cliente | Formulario | Segmento | ID de llamada anterior | UTM | ID Submotivos | Submotivos de atencion | Carpeta | Categorizacion-Derivacion | Modalidad de atencion | Tipo de cliente | Pregunta Botonera | Carpeta de motivos | Preferencia Usuario | Submotivos v2 | Sucursal de origen | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | T3270200138752 | C2509732198327020013875217307240683370 | AFP PlanVital Antofagasta | 20 | Actualizacion de datos | 1 | 2024-11-04 | AD | 1 | 12612953-K | NaN | HENRIQUEZ HUERTA, VANESSA | 25310066-4 | NaN | 09:40:38 | 09:41:08 | 00:00:30 | 00:10:30 | Otros | no | no | NaN | NaN | NaN | CARLOS ALBERTO RIASCOS ALOMIA | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | T3270200274435 | C2509732198327020027443517307334890300 | AFP PlanVital Antofagasta | 20 | Actualizacion de datos | 1 | 2024-11-04 | AD | 2 | 12612953-K | NaN | HENRIQUEZ HUERTA, VANESSA | 25328334-3 | NaN | 12:17:54 | 12:18:09 | 00:00:15 | 00:06:26 | Actualizacion de Datos | no | no | NaN | NaN | NaN | ELVIS JHONATHAN PAREDES SIESQUEN | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | T3270200199076 | C2509732202327020019907617307247753890 | AFP PlanVital Antofagasta | 20 | Certificados | 1 | 2024-11-04 | AC | 1 | 12612953-K | NaN | HENRIQUEZ HUERTA, VANESSA | 26268695-7 | NaN | 09:48:19 | 09:52:55 | 00:04:36 | 00:03:31 | Actualizacion de Datos | no | no | NaN | NaN | NaN | JULIO CESAR CASTILLO RODRIGUEZ | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | T3270200210373 | C2509732202327020021037317307250432900 | AFP PlanVital Antofagasta | 20 | Certificados | 1 | 2024-11-04 | AC | 2 | 12612953-K | NaN | HENRIQUEZ HUERTA, VANESSA | 19102988-7 | NaN | 09:53:30 | 09:57:23 | 00:03:53 | 00:08:57 | Certificados | no | no | NaN | NaN | NaN | PEDRO ANTONIO ANGEL BUGUENO | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | T3270200318250 | C2555532202327020031825017307254844290 | AFP PlanVital Antofagasta | 20 | Certificados | 3 | 2024-11-04 | AC | 3 | 19445974-2 | NaN | MARJORIE NEVENKA PIZARRO OCARANZA | 20246505-6 | NaN | 10:01:58 | 10:04:44 | 00:02:46 | 00:02:40 | Certificados | no | no | NaN | NaN | NaN | CAMILO ALFREDO MOLINA CARVAJAL | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | T3270200464273 | C2555532202327020046427317307268761580 | AFP PlanVital Antofagasta | 20 | Certificados | 3 | 2024-11-04 | AC | 4 | 19445974-2 | NaN | MARJORIE NEVENKA PIZARRO OCARANZA | 24740983-1 | NaN | 10:27:44 | 10:27:56 | 00:00:12 | 00:02:58 | Certificados | no | no | NaN | NaN | NaN | GABRIEL ZURITA RODRIGUEZ | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | T3270200587221 | C2555532202327020058722117307292716520 | AFP PlanVital Antofagasta | 20 | Certificados | 3 | 2024-11-04 | AC | 5 | 19445974-2 | NaN | MARJORIE NEVENKA PIZARRO OCARANZA | 19966775-0 | NaN | 11:06:27 | 11:07:51 | 00:01:24 | 00:03:25 | Certificados | no | no | NaN | NaN | NaN | VALERIA ELIZABETH MERCADO AGUIRRE | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | T3270200643964 | C2555532202327020064396417307302644760 | AFP PlanVital Antofagasta | 20 | Certificados | 3 | 2024-11-04 | AC | 6 | 19445974-2 | NaN | MARJORIE NEVENKA PIZARRO OCARANZA | 25812443-K | NaN | 11:24:03 | 11:24:24 | 00:00:21 | 00:14:14 | Certificados | no | no | NaN | NaN | NaN | JOSEPH BUISSERETH | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | T3270200784328 | C2545732202327020078432817307368992670 | AFP PlanVital Antofagasta | 20 | Certificados | 2 | 2024-11-04 | AC | 7 | 15769608-4 | NaN | REINADO AGUIRRE, MARLA | 19444357-9 | NaN | 13:14:44 | 13:14:59 | 00:00:15 | 00:19:29 | Otros | no | no | NaN | NaN | NaN | FRANCISCO JAVIER TAPIA MEZA | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | T3270200857982 | C2555532202327020085798217307420757140 | AFP PlanVital Antofagasta | 20 | Certificados | 3 | 2024-11-04 | AC | 8 | 19445974-2 | NaN | MARJORIE NEVENKA PIZARRO OCARANZA | 13013165-4 | NaN | 14:40:57 | 14:41:15 | 00:00:18 | 00:02:20 | Certificados | no | no | NaN | NaN | NaN | KATHERINE PAMELA ROJO ARAYA | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| ID Ticket | ID Llamada | Oficina | Codigo de Oficina | Fila | Modulo | Fecha | Prefijo Ticket | Nro. Ticket | DNI Ejecutivo | DNI Ejecutivo DV | Nombre Ejecutivo | DNI Cliente | DNI Cliente DV | Hora Emision Ticket | Hora Llamada | Tiempo Espera | Tiempo Atencion | Motivo Atencion | Perdido | Saltado | Email Cliente | Rating | Comentario | Nombre Cliente | Formulario | Segmento | ID de llamada anterior | UTM | ID Submotivos | Submotivos de atencion | Carpeta | Categorizacion-Derivacion | Modalidad de atencion | Tipo de cliente | Pregunta Botonera | Carpeta de motivos | Preferencia Usuario | Submotivos v2 | Sucursal de origen | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19031 | T3311224590840 | C2554932123331122459084017328012152630 | AFP PlanVital Vina del Mar | 47 | Otros Pensionado | 3 | 2024-11-28 | P | 5 | 16887527-4 | NaN | MAURICIO MAXIMILIANO LOBOS ROJAS | 13365128-4 | NaN | 10:39:50 | 10:40:15 | 00:00:25 | 00:07:19 | Certificados | no | no | NaN | NaN | NaN | JUAN FRANCISCO PEREZ ALVAREZ | NaN | A | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19032 | T3311224657236 | C2554832123331122465723617328046796820 | AFP PlanVital Vina del Mar | 47 | Otros Pensionado | 5 | 2024-11-28 | P | 6 | 10993573-5 | NaN | ALFARO MONDACA, CLAUDIA | 15083446-5 | NaN | 11:37:37 | 11:37:59 | 00:00:22 | 00:13:13 | Otros | no | no | CARANEDACISTERNAS@GMAIL.COM | NaN | NaN | CAROLINA VIVIANA ARANEDA CISTERNAS | NaN | NaN | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19033 | T3311224781957 | C2554932123331122478195717328083270940 | AFP PlanVital Vina del Mar | 47 | Otros Pensionado | 3 | 2024-11-28 | P | 7 | 16887527-4 | NaN | MAURICIO MAXIMILIANO LOBOS ROJAS | 19400071-5 | NaN | 12:38:01 | 12:38:47 | 00:00:46 | 00:06:04 | Otros | no | no | NaN | NaN | NaN | CAMILA FERNANDA POLANCO DALY | NaN | A | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19034 | T3311224874340 | C2512032123331122487434017328083907140 | AFP PlanVital Vina del Mar | 47 | Otros Pensionado | 4 | 2024-11-28 | P | 8 | 12848773-5 | NaN | OLIVARES LAGOS, MILENA | 8062217-1 | NaN | 12:39:34 | 12:39:50 | 00:00:16 | 00:03:44 | Otros | no | no | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19035 | T3311224144655 | C2554832124331122414465517327975321110 | AFP PlanVital Vina del Mar | 47 | Pago en exceso | 5 | 2024-11-28 | AP | 1 | 10993573-5 | NaN | ALFARO MONDACA, CLAUDIA | 10820061-8 | NaN | 09:34:04 | 09:38:52 | 00:04:48 | 00:00:47 | Actualizacion de Datos,Certificados | no | no | NaN | NaN | NaN | LUIS ALBERTO CACHANA VIDAL | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19036 | T3311224230283 | C2554932124331122423028317328213479500 | AFP PlanVital Vina del Mar | 47 | Pago en exceso | 3 | 2024-11-28 | AP | 2 | 16887527-4 | NaN | MAURICIO MAXIMILIANO LOBOS ROJAS | 12701243-1 | NaN | 16:15:30 | 16:15:47 | 00:00:17 | 00:02:15 | Otros | no | no | NaN | NaN | NaN | GERARDO ENRIQUE MORA HERNANDEZ | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19037 | T3311224143947 | C2554932126331122414394717328199563480 | AFP PlanVital Vina del Mar | 47 | Solicitud tramite de pension | 3 | 2024-11-28 | PT | 1 | 16887527-4 | NaN | MAURICIO MAXIMILIANO LOBOS ROJAS | 11621009-6 | NaN | 15:52:23 | 15:52:36 | 00:00:13 | 00:07:13 | Certificados | no | no | NaN | NaN | NaN | JAVIER ALEJANDRO MUNOZ ALVAREZ | NaN | A | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19038 | T3311204514206 | C2512032123331120451420617310750495730 | AFP PlanVital Vina del Mar | 47 | Otros Pensionado | 4 | 2024-11-08 | P | 5 | 12848773-5 | NaN | OLIVARES LAGOS, MILENA | 7713740-8 | NaN | 11:10:14 | 11:10:49 | 00:00:35 | NaN | NaN | no | no | NaN | NaN | NaN | ROSA ADRIANA ROJAS ALLENDE | NaN | P | NaN | NaN | NaN | NaN | Pensionado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19039 | T3294202381983 | C2551432011329420238198317315959125190 | AFP PlanVital Puerto Montt | 94 | Otros | 3 | 2024-11-14 | O | 3 | 16262795-3 | NaN | TOLEDO BARRIA, JESSICA CAROLINA | 12757126-0 | NaN | 11:51:21 | 11:51:52 | 00:00:31 | NaN | NaN | no | no | NaN | NaN | NaN | ADAN EUGENIO GALLARDO CARCAMO | NaN | A | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |
| 19040 | T3308223599521 | C2553431819330822359952117327378215580 | AFP PlanVital Tenderini | 50 | Giro APV o Cuenta 2 | 3 | 2024-11-27 | AG | 5 | 17051427-0 | NaN | ARRIAGADA RODRIGUEZ,NAYADET | 10355488-8 | NaN | 17:03:19 | 17:03:41 | 00:00:22 | NaN | NaN | no | no | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Afiliado | NaN | Presencial | NaN | NaN | NaN | NaN | NaN | NaN |